So we've got all these tools inside of Microsoft Excel that are going to assist you in having the ability
to audit an excel worksheet or larger scale.
The workbook itself and we've seen trace precedence trace the pennance and we've seen the watch window
.
Great techniques very powerful techniques to help you audit and worksheet and take a look at formulas
.
Now I want to show you one more here and this is a super quick feature.
This is called show formulas.
Now once again here's the scenario.
A co-worker sent you a workbook.
They've asked you hey can you take a look at this.
Make sure everything looks right.
Make sure my calculations are actually accurate before we print this out or send it off to our managers
.
Well I could open up the workbook like what I have open in front of you I'm under formula auditing worksheet
and I could go sell the cell and just confirm OK be happy 5:39 looks good sci fi through se'nnight.
Great.
Let's get D5.
OK.
And so on and so on.
It's like all these cells here that contain formulas but me doing that manually I'm probably going to
miss somethin.
So here's a really quick way to assist us in managing and auditing these formulas.
And it's a more visual at one glance bill to see all the formulas up on your formula tab.
Top your screen underneath formula auditing.
There's a button called show formulas and like I said super quick super simple.
You get that by and click.
This expands all your formulas.
Will you get that.
I love these simple things.
They make my life simple.
Then I can see all the formulas right there at a glance by scroll through I can see those larger formulas
there's the if statements and so on but one button press and it's a toggle button.
If I go right back up there and hit that button again show formulas it'll claps them zip them back up
again no longer seeing the formulas.
And great thing here.
If I show the formulas I can go to my file tab and I go to Prince and I can actually print it out showing
the formulas.
So if you want to make corrections right you get in there with your highlighter your red marker you
printed out start circling Thane's right.
We need to fix this year you need jump back into the document make this adjustment.
So on his own you can print out the show formulas featured here.
I hit my back arrow.
I mean toggling back off.
Take me back to my default document simple simple a quick button press toggle button showing and hiding
your formulas.
Tried out one button press